create procedure [dbo].[BAEEventGetRegistrantAnswers] @RegistrantID VARCHAR(16),
     @EventCode VARCHAR(16) as
SELECT QuestionID, Question, Answer
    FROM EventRegistrationAnswer AS a, EventSetupQuestion AS q
    WHERE q.EventCode = a.EventCode AND
        q.EventSetupQuestionID = a.QuestionID AND
        a.RegistrantID = @RegistrantID AND
        a.EventCode = @EventCode

GO